package cn.harvest.storage.bo.admin;

import java.util.List;

import cn.harvest.storage.dao.DAO;

public class EmploymentService {

	private DAO dao = DAO.getDAO();

	private EmploymentService() {

	}

	public static EmploymentService getService() {

		EmploymentService service = new EmploymentService();
		return service;
	}
	
	public List selectEmployment() {

		StringBuffer sql = new StringBuffer();
		sql.append(" SELECT em.employment_id, em.employment_name");
		sql.append(" FROM employment em");
		sql.append(" ORDER BY em.employment_id ");

		System.out.println("### - EmploymentService -> selectEmployment -> #SQL \r\n	 " + sql);
		return dao.selectBySQL(sql.toString());
	}

	public static void main(String[] args) {
		EmploymentService EmploymentService = new EmploymentService();
		EmploymentService.selectEmployment();

	}
}
